walmart_fuel_stations

Dataset statistics

Number of variables	23
Number of observations	5250
Missing cells	9646
Missing cells (%)	8.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	907.6 KiB
Average record size in memory	177.0 B

Variable types

Numeric	6
Text	6
Categorical	5
Boolean	6

Alerts

`Modified_Operating_Hours_` has constant value ""	Constant
`Fuel_Station_open_to_public_` has constant value ""	Constant
`businessunit_number` is highly overall correlated with `businessunit_status_code` and 2 other fields	High correlation
`businessunit_status_code` is highly overall correlated with `businessunit_number` and 2 other fields	High correlation
`bu_num` is highly overall correlated with `businessunit_number` and 2 other fields	High correlation
`businessunit_banner_description` is highly overall correlated with `businessunit_type_description`	High correlation
`businessunit_type_description` is highly overall correlated with `businessunit_number` and 2 other fields	High correlation
`businessunit_isstoreopen` is highly overall correlated with `businessunit_status_code`	High correlation
`Pharmacy_open_to_public_` is highly overall correlated with `Grocery_delivery_status` and 1 other fields	High correlation
`Grocery_delivery_status` is highly overall correlated with `Pharmacy_open_to_public_` and 1 other fields	High correlation
`Online_grocery_pickup_status` is highly overall correlated with `Pharmacy_open_to_public_` and 1 other fields	High correlation
`businessunit_banner_description` is highly imbalanced (52.3%)	Imbalance
`businessunit_isstoreopen` is highly imbalanced (96.2%)	Imbalance
`op_status` is highly imbalanced (99.3%)	Imbalance
`Pharmacy_open_to_public_` is highly imbalanced (99.7%)	Imbalance
`Modified_Operating_Hours_` has 5247 (99.9%) missing values	Missing
`Grocery_delivery_service` has 435 (8.3%) missing values	Missing
`Grocery_delivery_status` has 2385 (45.4%) missing values	Missing
`Online_grocery_pickup` has 106 (2.0%) missing values	Missing
`Online_grocery_pickup_status` has 1473 (28.1%) missing values	Missing
`objectid` has unique values	Unique
`businessunit_number` has unique values	Unique
`bu_num` has unique values	Unique

Reproduction

Analysis started	2023-10-22 10:05:59.441634
Analysis finished	2023-10-22 10:06:09.218187
Duration	9.78 seconds
Software version	ydata-profiling vv4.6.0
Download configuration	config.json

X
Real number (ℝ)

Distinct	5248
Distinct (%)	> 99.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-91.520243

Minimum	-159.36503
Maximum	-65.674303
Zeros	0
Zeros (%)	0.0%
Negative	5250
Negative (%)	100.0%
Memory size	41.1 KiB

Quantile statistics

Minimum	-159.36503
5-th percentile	-119.18436
Q1	-97.132078
median	-88.420169
Q3	-81.753295
95-th percentile	-74.692686
Maximum	-65.674303
Range	93.690722
Interquartile range (IQR)	15.378783

Descriptive statistics

Standard deviation	13.529964
Coefficient of variation (CV)	-0.14783575
Kurtosis	1.3174184
Mean	-91.520243
Median Absolute Deviation (MAD)	7.550761
Skewness	-1.0579582
Sum	-480481.28
Variance	183.05993
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-84.848736	2	< 0.1%
-90.324403	2	< 0.1%
-94.149054	1	< 0.1%
-117.266426	1	< 0.1%
-83.470749	1	< 0.1%
-75.091761	1	< 0.1%
-120.609275	1	< 0.1%
-85.663857	1	< 0.1%
-96.856976	1	< 0.1%
-76.928412	1	< 0.1%
Other values (5238)	5238	99.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-159.365025	1	< 0.1%
-158.075334	1	< 0.1%
-158.034591	1	< 0.1%
-158.005571	1	< 0.1%
-157.978362	1	< 0.1%
-157.974452	1	< 0.1%
-157.862004	1	< 0.1%
-157.843233	1	< 0.1%
-157.842705	1	< 0.1%
-156.454892	1	< 0.1%

Value	Count	Frequency (%)
-65.674303	1	< 0.1%
-65.807268	1	< 0.1%
-65.889641	1	< 0.1%
-65.995746	1	< 0.1%
-65.997031	1	< 0.1%
-66.015882	1	< 0.1%
-66.020899	1	< 0.1%
-66.076049	1	< 0.1%
-66.087612	1	< 0.1%
-66.095026	1	< 0.1%

Y
Real number (ℝ)

Distinct	5247
Distinct (%)	99.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	36.45154

Minimum	17.980621
Maximum	64.856378
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	41.1 KiB

Quantile statistics

Minimum	17.980621
5-th percentile	28.029205
Q1	32.959555
median	36.181191
Q3	40.369625
95-th percentile	44.552793
Maximum	64.856378
Range	46.875757
Interquartile range (IQR)	7.4100702

Descriptive statistics

Standard deviation	5.2184587
Coefficient of variation (CV)	0.14316154
Kurtosis	0.55972775
Mean	36.45154
Median Absolute Deviation (MAD)	3.6537935
Skewness	-0.052431905
Sum	191370.58
Variance	27.232311
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
41.473938	2	< 0.1%
29.470675	2	< 0.1%
42.999723	2	< 0.1%
47.658489	1	< 0.1%
39.999062	1	< 0.1%
37.340296	1	< 0.1%
38.088633	1	< 0.1%
32.862217	1	< 0.1%
40.224885	1	< 0.1%
33.069254	1	< 0.1%
Other values (5237)	5237	99.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
17.980621	1	< 0.1%
17.993681	1	< 0.1%
17.99736	1	< 0.1%
18.016813	1	< 0.1%
18.044336	1	< 0.1%
18.122626	1	< 0.1%
18.141237	1	< 0.1%
18.155224	1	< 0.1%
18.243301	1	< 0.1%
18.246762	1	< 0.1%

Value	Count	Frequency (%)
64.856378	1	< 0.1%
61.568719	1	< 0.1%
61.309037	1	< 0.1%
61.211988	1	< 0.1%
61.192239	1	< 0.1%
61.140195	1	< 0.1%
60.564278	1	< 0.1%
57.811934	1	< 0.1%
55.375474	1	< 0.1%
48.818547	1	< 0.1%

objectid
Real number (ℝ)

UNIQUE

Distinct	5250
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	32402.935

Minimum	29040
Maximum	36706
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	41.1 KiB

Quantile statistics

Minimum	29040
5-th percentile	29377.45
Q1	30471.25
median	32128.5
Q3	34228.75
95-th percentile	36274.55
Maximum	36706
Range	7666
Interquartile range (IQR)	3757.5

Descriptive statistics

Standard deviation	2173.7084
Coefficient of variation (CV)	0.067083689
Kurtosis	-1.0958443
Mean	32402.935
Median Absolute Deviation (MAD)	1873.5
Skewness	0.27415283
Sum	1.7011541 × 10⁸
Variance	4725008.1
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
29040	1	< 0.1%
33536	1	< 0.1%
33533	1	< 0.1%
33532	1	< 0.1%
33531	1	< 0.1%
33530	1	< 0.1%
33529	1	< 0.1%
33527	1	< 0.1%
33525	1	< 0.1%
33524	1	< 0.1%
Other values (5240)	5240	99.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
29040	1	< 0.1%
29041	1	< 0.1%
29042	1	< 0.1%
29043	1	< 0.1%
29044	1	< 0.1%
29045	1	< 0.1%
29046	1	< 0.1%
29047	1	< 0.1%
29048	1	< 0.1%
29049	1	< 0.1%

Value	Count	Frequency (%)
36706	1	< 0.1%
36705	1	< 0.1%
36704	1	< 0.1%
36702	1	< 0.1%
36700	1	< 0.1%
36698	1	< 0.1%
36695	1	< 0.1%
36693	1	< 0.1%
36690	1	< 0.1%
36688	1	< 0.1%

businessunit_name
Text

Distinct	4795
Distinct (%)	91.3%
Missing	0
Missing (%)	0.0%
Memory size	41.1 KiB

Length

Max length	42
Median length	36
Mean length	13.968762
Min length	5

Characters and Unicode

Total characters	73336
Distinct characters	70
Distinct categories	9 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	4435 ?
Unique (%)	84.5%

Sample

1st row	ROGERS, AR
2nd row	TUNKHANNOCK, PA
3rd row	TAHLEQUAH OK
4th row	TRACY, CA
5th row	BENTONVILLE, AR

Value	Count	Frequency (%)
tx	585	4.4%
fl	371	2.8%
ca	306	2.3%
ga	211	1.6%
nc	210	1.6%
il	180	1.4%
oh	167	1.3%
city	163	1.2%
la	158	1.2%
pa	157	1.2%
Other values (3243)	10690	81.0%

Most occurring characters

Value	Count	Frequency (%)
	7957	10.9%
A	6356	8.7%
N	5106	7.0%
E	5093	6.9%
L	4848	6.6%
O	4608	6.3%
I	3791	5.2%
R	3712	5.1%
T	3649	5.0%
S	3397	4.6%
Other values (60)	24819	33.8%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	60212	82.1%
Space Separator	7957	10.9%
Other Punctuation	2595	3.5%
Lowercase Letter	908	1.2%
Open Punctuation	678	0.9%
Close Punctuation	678	0.9%
Decimal Number	241	0.3%
Dash Punctuation	65	0.1%
Modifier Symbol	2	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	6356	10.6%
N	5106	8.5%
E	5093	8.5%
L	4848	8.1%
O	4608	7.7%
I	3791	6.3%
R	3712	6.2%
T	3649	6.1%
S	3397	5.6%
C	2561	4.3%
Other values (16)	17091	28.4%

Lowercase Letter

Value	Count	Frequency (%)
a	111	12.2%
e	92	10.1%
o	91	10.0%
n	80	8.8%
l	76	8.4%
r	74	8.1%
i	55	6.1%
s	54	5.9%
t	52	5.7%
d	33	3.6%
Other values (14)	190	20.9%

Decimal Number

Value	Count	Frequency (%)
1	83	34.4%
2	42	17.4%
0	37	15.4%
6	15	6.2%
7	13	5.4%
3	13	5.4%
4	13	5.4%
5	11	4.6%
8	9	3.7%
9	5	2.1%

Other Punctuation

Value	Count	Frequency (%)
,	2422	93.3%
.	86	3.3%
/	42	1.6%
&	38	1.5%
'	7	0.3%

Space Separator

Value	Count	Frequency (%)
	7957	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	678	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	678	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	65	100.0%

Modifier Symbol

Value	Count	Frequency (%)
`	2	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	61120	83.3%
Common	12216	16.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	6356	10.4%
N	5106	8.4%
E	5093	8.3%
L	4848	7.9%
O	4608	7.5%
I	3791	6.2%
R	3712	6.1%
T	3649	6.0%
S	3397	5.6%
C	2561	4.2%
Other values (40)	17999	29.4%

Common

Value	Count	Frequency (%)
	7957	65.1%
,	2422	19.8%
(	678	5.6%
)	678	5.6%
.	86	0.7%
1	83	0.7%
-	65	0.5%
/	42	0.3%
2	42	0.3%
&	38	0.3%
Other values (10)	125	1.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	73336	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	7957	10.9%
A	6356	8.7%
N	5106	7.0%
E	5093	6.9%
L	4848	6.6%
O	4608	6.3%
I	3791	5.2%
R	3712	5.1%
T	3649	5.0%
S	3397	4.6%
Other values (60)	24819	33.8%

businessunit_number
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	5250
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3184.756

Minimum	1
Maximum	9894
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	41.1 KiB

Quantile statistics

Minimum	1
5-th percentile	278.45
Q1	1371.25
median	2810.5
Q3	4925.75
95-th percentile	6955.75
Maximum	9894
Range	9893
Interquartile range (IQR)	3554.5

Descriptive statistics

Standard deviation	2159.4932
Coefficient of variation (CV)	0.6780718
Kurtosis	-0.73966895
Mean	3184.756
Median Absolute Deviation (MAD)	1694
Skewness	0.47704628
Sum	16719969
Variance	4663411
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	1	< 0.1%
5894	1	< 0.1%
5891	1	< 0.1%
5890	1	< 0.1%
589	1	< 0.1%
5889	1	< 0.1%
5888	1	< 0.1%
5886	1	< 0.1%
5884	1	< 0.1%
5883	1	< 0.1%
Other values (5240)	5240	99.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%
10	1	< 0.1%
11	1	< 0.1%

Value	Count	Frequency (%)
9894	1	< 0.1%
8958	1	< 0.1%
8930	1	< 0.1%
8331	1	< 0.1%
8299	1	< 0.1%
8298	1	< 0.1%
8297	1	< 0.1%
8296	1	< 0.1%
8295	1	< 0.1%
8294	1	< 0.1%

businessunit_banner_description
Categorical

HIGH CORRELATION IMBALANCE

Distinct	8
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	41.1 KiB

WM Supercenter	3575
Neighborhood Market	683
Sam's Club	602
Wal-Mart	364
WM On Campus/RX Facilities	16
Other values (3)	10

Length

Max length	26
Median length	14
Mean length	13.824381
Min length	8

Characters and Unicode

Total characters	72578
Distinct characters	42
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	< 0.1%

Sample

1st row	WM Supercenter
2nd row	WM Supercenter
3rd row	WM Supercenter
4th row	WM Supercenter
5th row	WM Supercenter

Common Values

Value	Count	Frequency (%)
WM Supercenter	3575	68.1%
Neighborhood Market	683	13.0%
Sam's Club	602	11.5%
Wal-Mart	364	6.9%
WM On Campus/RX Facilities	16	0.3%
Walmart Fuel Station	8	0.2%
WM ONLINE PICKUP/DELIVERY	1	< 0.1%
STAND ALONE PICKUP	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
wm	3592	35.3%
supercenter	3575	35.1%
neighborhood	683	6.7%
market	683	6.7%
sam's	602	5.9%
club	602	5.9%
wal-mart	364	3.6%
campus/rx	16	0.2%
facilities	16	0.2%
on	16	0.2%
Other values (8)	29	0.3%

Most occurring characters

Value	Count	Frequency (%)
e	12115	16.7%
r	8888	12.2%
	4928	6.8%
t	4662	6.4%
M	4639	6.4%
u	4201	5.8%
S	4186	5.8%
W	3964	5.5%
n	3599	5.0%
p	3591	4.9%
Other values (32)	17805	24.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	52470	72.3%
Uppercase Letter	14197	19.6%
Space Separator	4928	6.8%
Other Punctuation	619	0.9%
Dash Punctuation	364	0.5%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
M	4639	32.7%
S	4186	29.5%
W	3964	27.9%
N	687	4.8%
C	620	4.4%
F	24	0.2%
O	18	0.1%
R	17	0.1%
X	16	0.1%
P	4	< 0.1%
Other values (10)	22	0.2%

Lowercase Letter

Value	Count	Frequency (%)
e	12115	23.1%
r	8888	16.9%
t	4662	8.9%
u	4201	8.0%
n	3599	6.9%
p	3591	6.8%
c	3591	6.8%
a	2069	3.9%
o	2057	3.9%
h	1366	2.6%
Other values (8)	6331	12.1%

Other Punctuation

Value	Count	Frequency (%)
'	602	97.3%
/	17	2.7%

Space Separator

Value	Count	Frequency (%)
	4928	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	364	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	66667	91.9%
Common	5911	8.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	12115	18.2%
r	8888	13.3%
t	4662	7.0%
M	4639	7.0%
u	4201	6.3%
S	4186	6.3%
W	3964	5.9%
n	3599	5.4%
p	3591	5.4%
c	3591	5.4%
Other values (28)	13231	19.8%

Common

Value	Count	Frequency (%)
	4928	83.4%
'	602	10.2%
-	364	6.2%
/	17	0.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	72578	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	12115	16.7%
r	8888	12.2%
	4928	6.8%
t	4662	6.4%
M	4639	6.4%
u	4201	5.8%
S	4186	5.8%
W	3964	5.5%
n	3599	5.0%
p	3591	4.9%
Other values (32)	17805	24.5%

businessunit_type_description
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	41.1 KiB

Retail	4648
Wholesale	602

Length

Max length	9
Median length	6
Mean length	6.344
Min length	6

Characters and Unicode

Total characters	33306
Distinct characters	10
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Retail
2nd row	Retail
3rd row	Retail
4th row	Retail
5th row	Retail

Common Values

Value	Count	Frequency (%)
Retail	4648	88.5%
Wholesale	602	11.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
retail	4648	88.5%
wholesale	602	11.5%

Most occurring characters

Value	Count	Frequency (%)
e	5852	17.6%
l	5852	17.6%
a	5250	15.8%
R	4648	14.0%
t	4648	14.0%
i	4648	14.0%
W	602	1.8%
h	602	1.8%
o	602	1.8%
s	602	1.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	28056	84.2%
Uppercase Letter	5250	15.8%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	5852	20.9%
l	5852	20.9%
a	5250	18.7%
t	4648	16.6%
i	4648	16.6%
h	602	2.1%
o	602	2.1%
s	602	2.1%

Uppercase Letter

Value	Count	Frequency (%)
R	4648	88.5%
W	602	11.5%

Most occurring scripts

Value	Count	Frequency (%)
Latin	33306	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	5852	17.6%
l	5852	17.6%
a	5250	15.8%
R	4648	14.0%
t	4648	14.0%
i	4648	14.0%
W	602	1.8%
h	602	1.8%
o	602	1.8%
s	602	1.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	33306	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	5852	17.6%
l	5852	17.6%
a	5250	15.8%
R	4648	14.0%
t	4648	14.0%
i	4648	14.0%
W	602	1.8%
h	602	1.8%
o	602	1.8%
s	602	1.8%

businessunit_isstoreopen
Boolean

HIGH CORRELATION IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	5.3 KiB

True	5229
False	21

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
True	5229	99.6%
False	21	0.4%

facilitydetails_location_locati
Text

Distinct	5241
Distinct (%)	99.8%
Missing	0
Missing (%)	0.0%
Memory size	41.1 KiB

Length

Max length	41
Median length	35
Mean length	17.665524
Min length	8

Characters and Unicode

Total characters	92744
Distinct characters	52
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	5234 ?
Unique (%)	99.7%

Sample

1st row	2110 W WALNUT ST
2nd row	808 HUNTER HWY
3rd row	2020 S MUSKOGEE AVE
4th row	3010 W GRANT LINE RD
5th row	406 S WALTON BLVD

Value	Count	Frequency (%)
rd	994	5.0%
st	790	4.0%
ave	619	3.1%
dr	571	2.9%
blvd	569	2.9%
s	533	2.7%
w	506	2.6%
n	500	2.5%
e	468	2.4%
highway	357	1.8%
Other values (5682)	13788	70.0%

Most occurring characters

Value	Count	Frequency (%)
	14445	15.6%
E	5556	6.0%
R	4977	5.4%
A	4865	5.2%
0	4542	4.9%
1	4176	4.5%
S	3806	4.1%
N	3742	4.0%
T	3673	4.0%
D	3450	3.7%
Other values (42)	39512	42.6%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	56026	60.4%
Decimal Number	22138	23.9%
Space Separator	14445	15.6%
Other Punctuation	101	0.1%
Dash Punctuation	24	< 0.1%
Lowercase Letter	10	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	5556	9.9%
R	4977	8.9%
A	4865	8.7%
S	3806	6.8%
N	3742	6.7%
T	3673	6.6%
D	3450	6.2%
L	3357	6.0%
O	2951	5.3%
I	2727	4.9%
Other values (17)	16922	30.2%

Decimal Number

Value	Count	Frequency (%)
0	4542	20.5%
1	4176	18.9%
5	2647	12.0%
2	2531	11.4%
3	1919	8.7%
4	1592	7.2%
7	1275	5.8%
6	1239	5.6%
9	1115	5.0%
8	1102	5.0%

Lowercase Letter

Value	Count	Frequency (%)
y	2	20.0%
d	2	20.0%
k	1	10.0%
w	1	10.0%
c	1	10.0%
a	1	10.0%
m	1	10.0%
e	1	10.0%

Other Punctuation

Value	Count	Frequency (%)
.	86	85.1%
#	6	5.9%
,	4	4.0%
/	3	3.0%
'	2	2.0%

Space Separator

Value	Count	Frequency (%)
	14445	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	24	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	56036	60.4%
Common	36708	39.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	5556	9.9%
R	4977	8.9%
A	4865	8.7%
S	3806	6.8%
N	3742	6.7%
T	3673	6.6%
D	3450	6.2%
L	3357	6.0%
O	2951	5.3%
I	2727	4.9%
Other values (25)	16932	30.2%

Common

Value	Count	Frequency (%)
	14445	39.4%
0	4542	12.4%
1	4176	11.4%
5	2647	7.2%
2	2531	6.9%
3	1919	5.2%
4	1592	4.3%
7	1275	3.5%
6	1239	3.4%
9	1115	3.0%
Other values (7)	1227	3.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	92743	> 99.9%
None	1	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	14445	15.6%
E	5556	6.0%
R	4977	5.4%
A	4865	5.2%
0	4542	4.9%
1	4176	4.5%
S	3806	4.1%
N	3742	4.0%
T	3673	4.0%
D	3450	3.7%
Other values (41)	39511	42.6%

None

Value	Count	Frequency (%)
Ñ	1	100.0%

facilitydetails_location_loca_1
Text

Distinct	2682
Distinct (%)	51.1%
Missing	0
Missing (%)	0.0%
Memory size	41.1 KiB

Length

Max length	22
Median length	19
Mean length	8.8057143
Min length	3

Characters and Unicode

Total characters	46230
Distinct characters	29
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1784 ?
Unique (%)	34.0%

Sample

1st row	ROGERS
2nd row	TUNKHANNOCK
3rd row	TAHLEQUAH
4th row	TRACY
5th row	BENTONVILLE

Value	Count	Frequency (%)
city	155	2.4%
san	68	1.0%
beach	60	0.9%
springs	59	0.9%
fort	52	0.8%
lake	45	0.7%
north	44	0.7%
west	42	0.6%
park	38	0.6%
las	37	0.6%
Other values (2538)	5986	90.9%

Most occurring characters

Value	Count	Frequency (%)
A	4441	9.6%
E	4414	9.5%
O	3767	8.1%
N	3686	8.0%
L	3677	8.0%
R	3211	6.9%
I	2926	6.3%
S	2664	5.8%
T	2533	5.5%
C	1562	3.4%
Other values (19)	13349	28.9%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	44892	97.1%
Space Separator	1336	2.9%
Dash Punctuation	1	< 0.1%
Other Punctuation	1	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	4441	9.9%
E	4414	9.8%
O	3767	8.4%
N	3686	8.2%
L	3677	8.2%
R	3211	7.2%
I	2926	6.5%
S	2664	5.9%
T	2533	5.6%
C	1562	3.5%
Other values (16)	12011	26.8%

Space Separator

Value	Count	Frequency (%)
	1336	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	1	100.0%

Other Punctuation

Value	Count	Frequency (%)
.	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	44892	97.1%
Common	1338	2.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	4441	9.9%
E	4414	9.8%
O	3767	8.4%
N	3686	8.2%
L	3677	8.2%
R	3211	7.2%
I	2926	6.5%
S	2664	5.9%
T	2533	5.6%
C	1562	3.5%
Other values (16)	12011	26.8%

Common

Value	Count	Frequency (%)
	1336	99.9%
-	1	0.1%
.	1	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	46230	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	4441	9.6%
E	4414	9.5%
O	3767	8.1%
N	3686	8.0%
L	3677	8.0%
R	3211	6.9%
I	2926	6.3%
S	2664	5.8%
T	2533	5.5%
C	1562	3.4%
Other values (19)	13349	28.9%

facilitydetails_location_loca_2
Text

Distinct	1236
Distinct (%)	23.5%
Missing	0
Missing (%)	0.0%
Memory size	41.1 KiB

Length

Max length	28
Median length	25
Mean length	7.3194286
Min length	3

Characters and Unicode

Total characters	38427
Distinct characters	41
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	574 ?
Unique (%)	10.9%

Sample

1st row	BENTON
2nd row	WYOMING
3rd row	CHEROKEE
4th row	SAN JOAQUIN
5th row	BENTON

Value	Count	Frequency (%)
st	82	1.4%
jefferson	74	1.3%
maricopa	70	1.2%
orange	68	1.2%
san	67	1.1%
harris	60	1.0%
washington	57	1.0%
dallas	56	1.0%
tarrant	53	0.9%
city	53	0.9%
Other values (1251)	5195	89.0%

Most occurring characters

Value	Count	Frequency (%)
A	4423	11.5%
E	3635	9.5%
O	3200	8.3%
N	3146	8.2%
R	2859	7.4%
L	2621	6.8%
S	2288	6.0%
I	2094	5.4%
T	1731	4.5%
C	1451	3.8%
Other values (31)	10979	28.6%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	37715	98.1%
Space Separator	586	1.5%
Other Punctuation	86	0.2%
Dash Punctuation	23	0.1%
Lowercase Letter	17	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	4423	11.7%
E	3635	9.6%
O	3200	8.5%
N	3146	8.3%
R	2859	7.6%
L	2621	6.9%
S	2288	6.1%
I	2094	5.6%
T	1731	4.6%
C	1451	3.8%
Other values (16)	10267	27.2%

Lowercase Letter

Value	Count	Frequency (%)
r	2	11.8%
n	2	11.8%
e	2	11.8%
w	2	11.8%
a	2	11.8%
l	2	11.8%
i	1	5.9%
t	1	5.9%
c	1	5.9%
s	1	5.9%

Other Punctuation

Value	Count	Frequency (%)
.	82	95.3%
'	4	4.7%

Space Separator

Value	Count	Frequency (%)
	586	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	23	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	37732	98.2%
Common	695	1.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	4423	11.7%
E	3635	9.6%
O	3200	8.5%
N	3146	8.3%
R	2859	7.6%
L	2621	6.9%
S	2288	6.1%
I	2094	5.5%
T	1731	4.6%
C	1451	3.8%
Other values (27)	10284	27.3%

Common

Value	Count	Frequency (%)
	586	84.3%
.	82	11.8%
-	23	3.3%
'	4	0.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	38427	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	4423	11.5%
E	3635	9.5%
O	3200	8.3%
N	3146	8.2%
R	2859	7.4%
L	2621	6.8%
S	2288	6.0%
I	2094	5.4%
T	1731	4.5%
C	1451	3.8%
Other values (31)	10979	28.6%

facilitydetails_location_loca_3
Text

Distinct	52
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Memory size	41.1 KiB

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	10500
Distinct characters	24
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	AR
2nd row	PA
3rd row	OK
4th row	CA
5th row	AR

Value	Count	Frequency (%)
tx	597	11.4%
fl	389	7.4%
ca	310	5.9%
nc	214	4.1%
ga	212	4.0%
il	185	3.5%
oh	171	3.3%
pa	159	3.0%
mo	156	3.0%
tn	150	2.9%
Other values (42)	2707	51.6%

Most occurring characters

Value	Count	Frequency (%)
A	1557	14.8%
N	946	9.0%
T	861	8.2%
L	856	8.2%
C	787	7.5%
I	643	6.1%
M	638	6.1%
O	611	5.8%
X	597	5.7%
F	389	3.7%
Other values (14)	2615	24.9%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	10500	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	1557	14.8%
N	946	9.0%
T	861	8.2%
L	856	8.2%
C	787	7.5%
I	643	6.1%
M	638	6.1%
O	611	5.8%
X	597	5.7%
F	389	3.7%
Other values (14)	2615	24.9%

Most occurring scripts

Value	Count	Frequency (%)
Latin	10500	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	1557	14.8%
N	946	9.0%
T	861	8.2%
L	856	8.2%
C	787	7.5%
I	643	6.1%
M	638	6.1%
O	611	5.8%
X	597	5.7%
F	389	3.7%
Other values (14)	2615	24.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	10500	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	1557	14.8%
N	946	9.0%
T	861	8.2%
L	856	8.2%
C	787	7.5%
I	643	6.1%
M	638	6.1%
O	611	5.8%
X	597	5.7%
F	389	3.7%
Other values (14)	2615	24.9%

facilitydetails_location_loca_8
Text

Distinct	5157
Distinct (%)	98.2%
Missing	0
Missing (%)	0.0%
Memory size	41.1 KiB

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	52500
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	5064 ?
Unique (%)	96.5%

Sample

1st row	72756-3246
2nd row	18657-8071
3rd row	74464-5439
4th row	95304-9402
5th row	72712-5705

Value	Count	Frequency (%)
57106-0704	2	< 0.1%
28083-6426	2	< 0.1%
76542-5201	2	< 0.1%
44011-1069	2	< 0.1%
21237-3034	2	< 0.1%
00659-0000	2	< 0.1%
15301-2974	2	< 0.1%
70345-4053	2	< 0.1%
71111-0000	2	< 0.1%
30165-1913	2	< 0.1%
Other values (5147)	5230	99.6%

Most occurring characters

Value	Count	Frequency (%)
0	6925	13.2%
1	5370	10.2%
3	5342	10.2%
2	5294	10.1%
-	5250	10.0%
4	4633	8.8%
5	4430	8.4%
7	4397	8.4%
6	4110	7.8%
8	3607	6.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	47250	90.0%
Dash Punctuation	5250	10.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	6925	14.7%
1	5370	11.4%
3	5342	11.3%
2	5294	11.2%
4	4633	9.8%
5	4430	9.4%
7	4397	9.3%
6	4110	8.7%
8	3607	7.6%
9	3142	6.6%

Dash Punctuation

Value	Count	Frequency (%)
-	5250	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	52500	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	6925	13.2%
1	5370	10.2%
3	5342	10.2%
2	5294	10.1%
-	5250	10.0%
4	4633	8.8%
5	4430	8.4%
7	4397	8.4%
6	4110	7.8%
8	3607	6.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	52500	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	6925	13.2%
1	5370	10.2%
3	5342	10.2%
2	5294	10.1%
-	5250	10.0%
4	4633	8.8%
5	4430	8.4%
7	4397	8.4%
6	4110	7.8%
8	3607	6.9%

businessunit_status_code
Real number (ℝ)

HIGH CORRELATION

Distinct	6
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.4851429

Minimum	0
Maximum	6
Zeros	5
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	41.1 KiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	2
median	2
Q3	5
95-th percentile	5
Maximum	6
Range	6
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	1.5085545
Coefficient of variation (CV)	0.43285298
Kurtosis	-1.9687251
Mean	3.4851429
Median Absolute Deviation (MAD)	0
Skewness	0.022313369
Sum	18297
Variance	2.2757365
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
2	2649	50.5%
5	2572	49.0%
6	22	0.4%
0	5	0.1%
4	1	< 0.1%
3	1	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	5	0.1%
2	2649	50.5%
3	1	< 0.1%
4	1	< 0.1%
5	2572	49.0%
6	22	0.4%

Value	Count	Frequency (%)
6	22	0.4%
5	2572	49.0%
4	1	< 0.1%
3	1	< 0.1%
2	2649	50.5%
0	5	0.1%

op_status
Categorical

IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	41.1 KiB

Open	5247
Closed	3

Length

Max length	6
Median length	4
Mean length	4.0011429
Min length	4

Characters and Unicode

Total characters	21006
Distinct characters	9
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Open
2nd row	Open
3rd row	Open
4th row	Open
5th row	Open

Common Values

Value	Count	Frequency (%)
Open	5247	99.9%
Closed	3	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
open	5247	99.9%
closed	3	0.1%

Most occurring characters

Value	Count	Frequency (%)
e	5250	25.0%
O	5247	25.0%
p	5247	25.0%
n	5247	25.0%
C	3	< 0.1%
l	3	< 0.1%
o	3	< 0.1%
s	3	< 0.1%
d	3	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	15756	75.0%
Uppercase Letter	5250	25.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	5250	33.3%
p	5247	33.3%
n	5247	33.3%
l	3	< 0.1%
o	3	< 0.1%
s	3	< 0.1%
d	3	< 0.1%

Uppercase Letter

Value	Count	Frequency (%)
O	5247	99.9%
C	3	0.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	21006	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	5250	25.0%
O	5247	25.0%
p	5247	25.0%
n	5247	25.0%
C	3	< 0.1%
l	3	< 0.1%
o	3	< 0.1%
s	3	< 0.1%
d	3	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	21006	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	5250	25.0%
O	5247	25.0%
p	5247	25.0%
n	5247	25.0%
C	3	< 0.1%
l	3	< 0.1%
o	3	< 0.1%
s	3	< 0.1%
d	3	< 0.1%

Modified_Operating_Hours_
Boolean

CONSTANT MISSING

Distinct	1
Distinct (%)	33.3%
Missing	5247
Missing (%)	99.9%
Memory size	10.4 KiB

False	3
(Missing)	5247

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	3	0.1%
(Missing)	5247	99.9%

Pharmacy_open_to_public_
Boolean

HIGH CORRELATION IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	5.3 KiB

True	5249
False	1

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
True	5249	> 99.9%
False	1	< 0.1%

Fuel_Station_open_to_public_
Boolean

CONSTANT

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	5.3 KiB

True	5250

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
True	5250	100.0%

bu_num
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	5250
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3184.756

Minimum	1
Maximum	9894
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	41.1 KiB

Quantile statistics

Minimum	1
5-th percentile	278.45
Q1	1371.25
median	2810.5
Q3	4925.75
95-th percentile	6955.75
Maximum	9894
Range	9893
Interquartile range (IQR)	3554.5

Descriptive statistics

Standard deviation	2159.4932
Coefficient of variation (CV)	0.6780718
Kurtosis	-0.73966895
Mean	3184.756
Median Absolute Deviation (MAD)	1694
Skewness	0.47704628
Sum	16719969
Variance	4663411
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	1	< 0.1%
5894	1	< 0.1%
5891	1	< 0.1%
5890	1	< 0.1%
589	1	< 0.1%
5889	1	< 0.1%
5888	1	< 0.1%
5886	1	< 0.1%
5884	1	< 0.1%
5883	1	< 0.1%
Other values (5240)	5240	99.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%
10	1	< 0.1%
11	1	< 0.1%

Value	Count	Frequency (%)
9894	1	< 0.1%
8958	1	< 0.1%
8930	1	< 0.1%
8331	1	< 0.1%
8299	1	< 0.1%
8298	1	< 0.1%
8297	1	< 0.1%
8296	1	< 0.1%
8295	1	< 0.1%
8294	1	< 0.1%

Grocery_delivery_service
Boolean

MISSING

Distinct	2
Distinct (%)	< 0.1%
Missing	435
Missing (%)	8.3%
Memory size	10.4 KiB

False	3157
True	1658
(Missing)	435

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	3157	60.1%
True	1658	31.6%
(Missing)	435	8.3%

Grocery_delivery_status
Categorical

HIGH CORRELATION MISSING

Distinct	2
Distinct (%)	0.1%
Missing	2385
Missing (%)	45.4%
Memory size	41.1 KiB

Available	2346
Not Available	519

Length

Max length	13
Median length	9
Mean length	9.7246073
Min length	9

Characters and Unicode

Total characters	27861
Distinct characters	11
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Available
2nd row	Not Available
3rd row	Not Available
4th row	Available
5th row	Available

Common Values

Value	Count	Frequency (%)
Available	2346	44.7%
Not Available	519	9.9%
(Missing)	2385	45.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
available	2865	84.7%
not	519	15.3%

Most occurring characters

Value	Count	Frequency (%)
a	5730	20.6%
l	5730	20.6%
A	2865	10.3%
v	2865	10.3%
i	2865	10.3%
b	2865	10.3%
e	2865	10.3%
N	519	1.9%
o	519	1.9%
t	519	1.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	23958	86.0%
Uppercase Letter	3384	12.1%
Space Separator	519	1.9%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	5730	23.9%
l	5730	23.9%
v	2865	12.0%
i	2865	12.0%
b	2865	12.0%
e	2865	12.0%
o	519	2.2%
t	519	2.2%

Uppercase Letter

Value	Count	Frequency (%)
A	2865	84.7%
N	519	15.3%

Space Separator

Value	Count	Frequency (%)
	519	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	27342	98.1%
Common	519	1.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	5730	21.0%
l	5730	21.0%
A	2865	10.5%
v	2865	10.5%
i	2865	10.5%
b	2865	10.5%
e	2865	10.5%
N	519	1.9%
o	519	1.9%
t	519	1.9%

Common

Value	Count	Frequency (%)
	519	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	27861	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	5730	20.6%
l	5730	20.6%
A	2865	10.3%
v	2865	10.3%
i	2865	10.3%
b	2865	10.3%
e	2865	10.3%
N	519	1.9%
o	519	1.9%
t	519	1.9%

Online_grocery_pickup
Boolean

MISSING

Distinct	2
Distinct (%)	< 0.1%
Missing	106
Missing (%)	2.0%
Memory size	10.4 KiB

True	3616
False	1528
(Missing)	106

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
True	3616	68.9%
False	1528	29.1%
(Missing)	106	2.0%

Online_grocery_pickup_status
Categorical

HIGH CORRELATION MISSING

Distinct	2
Distinct (%)	0.1%
Missing	1473
Missing (%)	28.1%
Memory size	41.1 KiB

Available	3144
Not Available	633

Length

Max length	13
Median length	9
Mean length	9.6703733
Min length	9

Characters and Unicode

Total characters	36525
Distinct characters	11
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Not Available
2nd row	Available
3rd row	Available
4th row	Not Available
5th row	Not Available

Common Values

Value	Count	Frequency (%)
Available	3144	59.9%
Not Available	633	12.1%
(Missing)	1473	28.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
available	3777	85.6%
not	633	14.4%

Most occurring characters

Value	Count	Frequency (%)
a	7554	20.7%
l	7554	20.7%
A	3777	10.3%
v	3777	10.3%
i	3777	10.3%
b	3777	10.3%
e	3777	10.3%
N	633	1.7%
o	633	1.7%
t	633	1.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	31482	86.2%
Uppercase Letter	4410	12.1%
Space Separator	633	1.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	7554	24.0%
l	7554	24.0%
v	3777	12.0%
i	3777	12.0%
b	3777	12.0%
e	3777	12.0%
o	633	2.0%
t	633	2.0%

Uppercase Letter

Value	Count	Frequency (%)
A	3777	85.6%
N	633	14.4%

Space Separator

Value	Count	Frequency (%)
	633	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	35892	98.3%
Common	633	1.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	7554	21.0%
l	7554	21.0%
A	3777	10.5%
v	3777	10.5%
i	3777	10.5%
b	3777	10.5%
e	3777	10.5%
N	633	1.8%
o	633	1.8%
t	633	1.8%

Common

Value	Count	Frequency (%)
	633	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	36525	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	7554	20.7%
l	7554	20.7%
A	3777	10.3%
v	3777	10.3%
i	3777	10.3%
b	3777	10.3%
e	3777	10.3%
N	633	1.7%
o	633	1.7%
t	633	1.7%

Auto

Heatmap
Table

	X	Y	objectid	businessunit_number	businessunit_status_code	bu_num	businessunit_banner_description	businessunit_type_description	businessunit_isstoreopen	op_status	Pharmacy_open_to_public_	Grocery_delivery_service	Grocery_delivery_status	Online_grocery_pickup	Online_grocery_pickup_status
X	1.000	0.087	-0.053	0.023	0.012	0.023	0.136	0.040	0.079	0.000	0.000	0.067	0.082	0.030	0.058
Y	0.087	1.000	-0.181	0.010	0.094	0.010	0.102	0.035	0.070	0.000	0.000	0.071	0.000	0.021	0.018
objectid	-0.053	-0.181	1.000	0.474	-0.200	0.474	0.221	0.500	0.024	0.041	0.000	0.059	0.000	0.037	0.000
businessunit_number	0.023	0.010	0.474	1.000	-0.552	1.000	0.411	0.789	0.042	0.000	0.000	0.124	0.000	0.074	0.023
businessunit_status_code	0.012	0.094	-0.200	-0.552	1.000	-0.552	0.228	0.064	0.977	0.000	0.000	0.043	0.000	0.076	0.000
bu_num	0.023	0.010	0.474	1.000	-0.552	1.000	0.411	0.789	0.042	0.000	0.000	0.124	0.000	0.074	0.023
businessunit_banner_description	0.136	0.102	0.221	0.411	0.228	0.411	1.000	0.999	0.218	0.000	0.000	0.200	0.048	0.172	0.044
businessunit_type_description	0.040	0.035	0.500	0.789	0.064	0.789	0.999	1.000	0.000	0.000	0.000	0.187	0.000	0.105	0.009
businessunit_isstoreopen	0.079	0.070	0.024	0.042	0.977	0.042	0.218	0.000	1.000	0.000	0.000	0.000	0.000	0.011	0.000
op_status	0.000	0.000	0.041	0.000	0.000	0.000	0.000	0.000	0.000	1.000	0.000	0.000	0.000	0.000	0.000
Pharmacy_open_to_public_	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	1.000	0.000	1.000	0.000	1.000
Grocery_delivery_service	0.067	0.071	0.059	0.124	0.043	0.124	0.200	0.187	0.000	0.000	0.000	1.000	0.331	0.422	0.249
Grocery_delivery_status	0.082	0.000	0.000	0.000	0.000	0.000	0.048	0.000	0.000	0.000	1.000	0.331	1.000	0.236	0.918
Online_grocery_pickup	0.030	0.021	0.037	0.074	0.076	0.074	0.172	0.105	0.011	0.000	0.000	0.422	0.236	1.000	0.175
Online_grocery_pickup_status	0.058	0.018	0.000	0.023	0.000	0.023	0.044	0.009	0.000	0.000	1.000	0.249	0.918	0.175	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	X	Y	objectid	businessunit_name	businessunit_number	businessunit_banner_description	businessunit_type_description	businessunit_isstoreopen	facilitydetails_location_locati	facilitydetails_location_loca_1	facilitydetails_location_loca_2	facilitydetails_location_loca_3	facilitydetails_location_loca_8	businessunit_status_code	op_status	Modified_Operating_Hours_	Pharmacy_open_to_public_	Fuel_Station_open_to_public_	bu_num	Grocery_delivery_service	Grocery_delivery_status	Online_grocery_pickup	Online_grocery_pickup_status
0	-94.149054	36.331300	29040	ROGERS, AR	1	WM Supercenter	Retail	True	2110 W WALNUT ST	ROGERS	BENTON	AR	72756-3246	5	Open	NaN	Y	Y	1	Yes	NaN	Yes	Not Available
1	-75.947441	41.523981	29041	TUNKHANNOCK, PA	2024	WM Supercenter	Retail	True	808 HUNTER HWY	TUNKHANNOCK	WYOMING	PA	18657-8071	5	Open	NaN	Y	Y	2024	No	Available	No	Available
2	-94.979814	35.888807	29042	TAHLEQUAH OK	10	WM Supercenter	Retail	True	2020 S MUSKOGEE AVE	TAHLEQUAH	CHEROKEE	OK	74464-5439	5	Open	NaN	Y	Y	10	No	NaN	No	Available
3	-121.471715	37.751659	29043	TRACY, CA	2025	WM Supercenter	Retail	True	3010 W GRANT LINE RD	TRACY	SAN JOAQUIN	CA	95304-9402	5	Open	NaN	Y	Y	2025	No	Not Available	No	Not Available
4	-94.224844	36.368173	29044	BENTONVILLE, AR	100	WM Supercenter	Retail	True	406 S WALTON BLVD	BENTONVILLE	BENTON	AR	72712-5705	5	Open	NaN	Y	Y	100	No	Not Available	No	Not Available
5	-66.642578	17.997360	29045	PONCE-PR	2026	WM Supercenter	Retail	True	3305 AVE.BARAMAYA SUITE 100	PONCE	PONCE	PR	00728-0000	5	Open	NaN	Y	Y	2026	NaN	NaN	Yes	NaN
6	-97.477003	25.925142	29046	BROWNSVILLE TX	1000	WM Supercenter	Retail	True	2721 BOCA CHICA BLVD	BROWNSVILLE	CAMERON	TX	78521-3501	5	Open	NaN	Y	Y	1000	Yes	NaN	Yes	Available
7	-78.835052	39.624903	29047	LAVALE, MD	2027	WM Supercenter	Retail	True	12500 COUNTRY CLUB MALL RD	LAVALE	ALLEGANY	MD	21502-7553	5	Open	NaN	Y	Y	2027	Yes	Available	Yes	Available
8	-104.664898	38.232316	29048	PUEBLO, CO	1001	WM Supercenter	Retail	True	4080 W NORTHERN AVE	PUEBLO	PUEBLO	CO	81005-3503	5	Open	NaN	Y	Y	1001	Yes	Available	Yes	Available
9	-117.455339	33.937071	29049	RIVERSIDE (S), CA	2028	WM Supercenter	Retail	True	5200 VAN BUREN BLVD	RIVERSIDE	RIVERSIDE	CA	92503-2544	5	Open	NaN	Y	Y	2028	No	NaN	Yes	NaN

	X	Y	objectid	businessunit_name	businessunit_number	businessunit_banner_description	businessunit_type_description	businessunit_isstoreopen	facilitydetails_location_locati	facilitydetails_location_loca_1	facilitydetails_location_loca_2	facilitydetails_location_loca_3	facilitydetails_location_loca_8	businessunit_status_code	op_status	Modified_Operating_Hours_	Pharmacy_open_to_public_	Fuel_Station_open_to_public_	bu_num	Grocery_delivery_service	Grocery_delivery_status	Online_grocery_pickup	Online_grocery_pickup_status
5240	-82.455718	29.063309	36688	DUNNELLON FL	960	WM Supercenter	Retail	True	11012 NO. WILLIAMS ST	DUNNELLON	MARION	FL	34432-8310	5	Open	NaN	Y	Y	960	Yes	Available	Yes	Available
5241	-90.498285	30.074716	36690	LAPLACE LA	961	WM Supercenter	Retail	True	1616 W AIRLINE HWY	LA PLACE	ST. JOHN THE BAPTIST PARISH	LA	70068-3331	5	Open	NaN	Y	Y	961	No	Available	Yes	Available
5242	-104.523275	37.138728	36693	TRINIDAD CO	962	WM Supercenter	Retail	True	2921 TOUPAL DR	TRINIDAD	LAS ANIMAS	CO	81082-8740	5	Open	NaN	Y	Y	962	Yes	Available	Yes	Available
5243	-97.794862	32.731493	36695	WEATHERFORD TX	963	WM Supercenter	Retail	True	1836 S MAIN ST	WEATHERFORD	PARKER	TX	76086-5506	5	Open	NaN	Y	Y	963	No	Available	Yes	Available
5244	-106.311596	31.682898	36698	EL PASO (S) TX	964	WM Supercenter	Retail	True	9441 ALAMEDA AVE	EL PASO	EL PASO	TX	79907-5601	5	Open	NaN	Y	Y	964	Yes	Available	Yes	Available
5245	-90.508577	44.021024	36700	TOMAH WI	965	WM Supercenter	Retail	True	222 W MCCOY BLVD	TOMAH	MONROE	WI	54660-3291	5	Open	NaN	Y	Y	965	No	NaN	Yes	NaN
5246	-108.561994	37.346568	36702	CORTEZ CO	966	WM Supercenter	Retail	True	1835 E MAIN ST	CORTEZ	MONTEZUMA	CO	81321-3037	5	Open	NaN	Y	Y	966	Yes	NaN	Yes	NaN
5247	-82.631218	28.458397	36704	SPRINGHILL / BROOKSVILLE	967	WM Supercenter	Retail	True	1485 COMMERCIAL WAY	SPRING HILL	HERNANDO	FL	34606-4525	5	Open	NaN	Y	Y	967	Yes	Available	Yes	Available
5248	-81.722251	28.006651	36705	WINTER HAVEN FL	968	WM Supercenter	Retail	True	355 CYPRESS GARDENS BLVD	WINTER HAVEN	POLK	FL	33880-4452	5	Open	NaN	Y	Y	968	Yes	Available	Yes	Available
5249	-89.088697	30.423224	36706	GULFPORT MS	969	WM Supercenter	Retail	True	9350 HIGHWAY 49	GULFPORT	HARRISON	MS	39503-4213	5	Open	NaN	Y	Y	969	No	Not Available	Yes	Available

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Lowercase Letter

Decimal Number

Other Punctuation

Space Separator

Open Punctuation

Close Punctuation

Dash Punctuation

Modifier Symbol

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Lowercase Letter

Other Punctuation

Space Separator

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Lowercase Letter

Other Punctuation

Space Separator

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

None

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Space Separator

Dash Punctuation

Other Punctuation

Most occurring scripts

Most frequent character per script

Latin